Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 584314 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 80.2 MiB |
| Average record size in memory | 144.0 B |
Variable types
| Numeric | 7 |
|---|---|
| Categorical | 5 |
| DateTime | 3 |
| Text | 2 |
item_id is highly overall correlated with Customer ID and 1 other fields | High correlation |
price is highly overall correlated with grand_total | High correlation |
grand_total is highly overall correlated with price | High correlation |
Customer ID is highly overall correlated with item_id and 1 other fields | High correlation |
status is highly overall correlated with BI Status | High correlation |
BI Status is highly overall correlated with status | High correlation |
Year is highly overall correlated with item_id and 1 other fields | High correlation |
status is highly imbalanced (51.7%) | Imbalance |
qty_ordered is highly skewed (γ1 = 185.8821021) | Skewed |
grand_total is highly skewed (γ1 = 254.9541717) | Skewed |
item_id has unique values | Unique |
grand_total has 9616 (1.6%) zeros | Zeros |
discount_amount has 376121 (64.4%) zeros | Zeros |
Reproduction
| Analysis started | 2023-09-19 08:21:24.025894 |
|---|---|
| Analysis finished | 2023-09-19 08:23:03.421173 |
| Duration | 1 minute and 39.4 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
item_id
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 584314 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 565590.35 |
| Minimum | 211131 |
|---|---|
| Maximum | 905208 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | 211131 |
|---|---|
| 5-th percentile | 247513.65 |
| Q1 | 394945.25 |
| median | 568301 |
| Q3 | 738981.75 |
| 95-th percentile | 872508.35 |
| Maximum | 905208 |
| Range | 694077 |
| Interquartile range (IQR) | 344036.5 |
Descriptive statistics
| Standard deviation | 200101.17 |
|---|---|
| Coefficient of variation (CV) | 0.35379171 |
| Kurtosis | -1.184214 |
| Mean | 565590.35 |
| Median Absolute Deviation (MAD) | 171855.5 |
| Skewness | -0.047040402 |
| Sum | 3.3048236 × 1011 |
| Variance | 4.0040479 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 211131 | 1 | < 0.1% |
| 682904 | 1 | < 0.1% |
| 682902 | 1 | < 0.1% |
| 682889 | 1 | < 0.1% |
| 682890 | 1 | < 0.1% |
| 682892 | 1 | < 0.1% |
| 682894 | 1 | < 0.1% |
| 682896 | 1 | < 0.1% |
| 682905 | 1 | < 0.1% |
| 682900 | 1 | < 0.1% |
| Other values (584304) | 584304 |
| Value | Count | Frequency (%) |
| 211131 | 1 | |
| 211133 | 1 | |
| 211134 | 1 | |
| 211135 | 1 | |
| 211136 | 1 | |
| 211137 | 1 | |
| 211138 | 1 | |
| 211139 | 1 | |
| 211140 | 1 | |
| 211141 | 1 |
| Value | Count | Frequency (%) |
| 905208 | 1 | |
| 905207 | 1 | |
| 905206 | 1 | |
| 905205 | 1 | |
| 905204 | 1 | |
| 905202 | 1 | |
| 905200 | 1 | |
| 905199 | 1 | |
| 905198 | 1 | |
| 905196 | 1 |
status
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| complete | |
|---|---|
| canceled | |
| received | |
| order_refunded | |
| refund | 8020 |
| Other values (11) | 4701 |
Length
| Max length | 14 |
|---|---|
| Median length | 8 |
| Mean length | 8.549944 |
| Min length | 2 |
Characters and Unicode
| Total characters | 4995852 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | complete |
|---|---|
| 2nd row | canceled |
| 3rd row | canceled |
| 4th row | complete |
| 5th row | order_refunded |
Common Values
| Value | Count | Frequency (%) |
| complete | 233684 | |
| canceled | 201127 | |
| received | 77284 | 13.2% |
| order_refunded | 59498 | 10.2% |
| refund | 8020 | 1.4% |
| cod | 2854 | 0.5% |
| paid | 1159 | 0.2% |
| closed | 494 | 0.1% |
| payment_review | 57 | < 0.1% |
| pending | 48 | < 0.1% |
| Other values (6) | 89 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| complete | 233684 | |
| canceled | 201127 | |
| received | 77284 | 13.2% |
| order_refunded | 59498 | 10.2% |
| refund | 8020 | 1.4% |
| cod | 2854 | 0.5% |
| paid | 1159 | 0.2% |
| closed | 494 | 0.1% |
| payment_review | 57 | < 0.1% |
| pending | 48 | < 0.1% |
| Other values (6) | 89 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1288780 | |
| c | 716607 | |
| d | 469559 | 9.4% |
| l | 435343 | 8.7% |
| o | 296594 | 5.9% |
| n | 268849 | 5.4% |
| r | 263898 | 5.3% |
| p | 235002 | 4.7% |
| m | 233741 | 4.7% |
| t | 233741 | 4.7% |
| Other values (14) | 553738 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4936282 | |
| Connector Punctuation | 59562 | 1.2% |
| Other Punctuation | 4 | < 0.1% |
| Uppercase Letter | 4 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1288780 | |
| c | 716607 | |
| d | 469559 | 9.5% |
| l | 435343 | 8.8% |
| o | 296594 | 6.0% |
| n | 268849 | 5.4% |
| r | 263898 | 5.3% |
| p | 235002 | 4.8% |
| m | 233741 | 4.7% |
| t | 233741 | 4.7% |
| Other values (11) | 494168 | 10.0% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 59562 |
Other Punctuation
| Value | Count | Frequency (%) |
| \ | 4 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 4 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4936286 | |
| Common | 59566 | 1.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1288780 | |
| c | 716607 | |
| d | 469559 | 9.5% |
| l | 435343 | 8.8% |
| o | 296594 | 6.0% |
| n | 268849 | 5.4% |
| r | 263898 | 5.3% |
| p | 235002 | 4.8% |
| m | 233741 | 4.7% |
| t | 233741 | 4.7% |
| Other values (12) | 494172 | 10.0% |
Common
| Value | Count | Frequency (%) |
| _ | 59562 | |
| \ | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4995852 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 1288780 | |
| c | 716607 | |
| d | 469559 | 9.4% |
| l | 435343 | 8.7% |
| o | 296594 | 5.9% |
| n | 268849 | 5.4% |
| r | 263898 | 5.3% |
| p | 235002 | 4.7% |
| m | 233741 | 4.7% |
| t | 233741 | 4.7% |
| Other values (14) | 553738 |
created_at
Date
| Distinct | 789 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| Minimum | 2016-07-01 00:00:00 |
|---|---|
| Maximum | 2018-08-28 00:00:00 |
sku
Text
| Distinct | 84869 |
|---|---|
| Distinct (%) | 14.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
Length
| Max length | 69 |
|---|---|
| Median length | 63 |
| Mean length | 20.254076 |
| Min length | 5 |
Characters and Unicode
| Total characters | 11834740 |
|---|---|
| Distinct characters | 94 |
| Distinct categories | 13 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 38636 ? |
|---|---|
| Unique (%) | 6.6% |
Sample
| 1st row | kreations_YI 06-L |
|---|---|
| 2nd row | kcc_Buy 2 Frey Air Freshener & Get 1 Kasual Body Spray Free |
| 3rd row | Ego_UP0017-999-MR0 |
| 4th row | kcc_krone deal |
| 5th row | BK7010400AG |
| Value | Count | Frequency (%) |
| 17805 | 1.9% | |
| infinix | 5978 | 0.7% |
| halwa | 5418 | 0.6% |
| hot | 4859 | 0.5% |
| black | 4616 | 0.5% |
| one | 4385 | 0.5% |
| of | 4104 | 0.4% |
| matsam59db75adb2f80 | 3775 | 0.4% |
| sohan | 3718 | 0.4% |
| al | 3661 | 0.4% |
| Other values (86302) | 856460 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 765671 | 6.5% |
| 5 | 536681 | 4.5% |
| 0 | 464114 | 3.9% |
| B | 423956 | 3.6% |
| - | 366666 | 3.1% |
| e | 348339 | 2.9% |
| 9 | 347767 | 2.9% |
| 1 | 345299 | 2.9% |
| a | 344863 | 2.9% |
| E | 340559 | 2.9% |
| Other values (84) | 7550825 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4515531 | |
| Decimal Number | 3266333 | |
| Lowercase Letter | 3026234 | |
| Dash Punctuation | 366685 | 3.1% |
| Space Separator | 336852 | 2.8% |
| Connector Punctuation | 297722 | 2.5% |
| Other Punctuation | 14679 | 0.1% |
| Open Punctuation | 4520 | < 0.1% |
| Close Punctuation | 4506 | < 0.1% |
| Math Symbol | 1525 | < 0.1% |
| Other values (3) | 153 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 348339 | |
| a | 344863 | |
| i | 247921 | 8.2% |
| o | 208073 | 6.9% |
| l | 201562 | 6.7% |
| r | 200688 | 6.6% |
| n | 195456 | 6.5% |
| t | 166925 | 5.5% |
| s | 143907 | 4.8% |
| c | 121305 | 4.0% |
| Other values (18) | 847195 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 765671 | |
| B | 423956 | 9.4% |
| E | 340559 | 7.5% |
| C | 327375 | 7.2% |
| F | 322824 | 7.1% |
| D | 288831 | 6.4% |
| M | 276375 | 6.1% |
| S | 231828 | 5.1% |
| T | 191223 | 4.2% |
| P | 175894 | 3.9% |
| Other values (17) | 1170995 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 536681 | |
| 0 | 464114 | |
| 9 | 347767 | |
| 1 | 345299 | |
| 2 | 281020 | |
| 3 | 274323 | |
| 7 | 271621 | |
| 4 | 262124 | |
| 6 | 242793 | |
| 8 | 240591 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 5968 | |
| . | 3473 | |
| / | 1987 | 13.5% |
| ' | 1174 | 8.0% |
| , | 922 | 6.3% |
| # | 392 | 2.7% |
| " | 280 | 1.9% |
| : | 251 | 1.7% |
| % | 231 | 1.6% |
| \ | 1 | < 0.1% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 1502 | |
| | | 12 | 0.8% |
| = | 9 | 0.6% |
| × | 2 | 0.1% |
Control
| Value | Count | Frequency (%) |
| 12 | ||
| 12 | ||
| 2 | 7.7% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 366666 | |
| – | 19 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 336309 | ||
| Â | 543 | 0.2% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 4495 | |
| [ | 25 | 0.6% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 4481 | |
| ] | 25 | 0.6% |
Other Symbol
| Value | Count | Frequency (%) |
| ° | 3 | |
| ® | 1 | 25.0% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 297722 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 123 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7541765 | |
| Common | 4292975 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 765671 | 10.2% |
| B | 423956 | 5.6% |
| e | 348339 | 4.6% |
| a | 344863 | 4.6% |
| E | 340559 | 4.5% |
| C | 327375 | 4.3% |
| F | 322824 | 4.3% |
| D | 288831 | 3.8% |
| M | 276375 | 3.7% |
| i | 247921 | 3.3% |
| Other values (45) | 3855051 |
Common
| Value | Count | Frequency (%) |
| 5 | 536681 | |
| 0 | 464114 | |
| - | 366666 | |
| 9 | 347767 | |
| 1 | 345299 | |
| 336309 | ||
| _ | 297722 | 6.9% |
| 2 | 281020 | 6.5% |
| 3 | 274323 | 6.4% |
| 7 | 271621 | 6.3% |
| Other values (29) | 771453 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11834127 | |
| None | 594 | < 0.1% |
| Punctuation | 19 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 765671 | 6.5% |
| 5 | 536681 | 4.5% |
| 0 | 464114 | 3.9% |
| B | 423956 | 3.6% |
| - | 366666 | 3.1% |
| e | 348339 | 2.9% |
| 9 | 347767 | 2.9% |
| 1 | 345299 | 2.9% |
| a | 344863 | 2.9% |
| E | 340559 | 2.9% |
| Other values (76) | 7550212 |
None
| Value | Count | Frequency (%) |
| Â | 543 | |
| è | 20 | 3.4% |
| È | 13 | 2.2% |
| é | 12 | 2.0% |
| ° | 3 | 0.5% |
| × | 2 | 0.3% |
| ® | 1 | 0.2% |
Punctuation
| Value | Count | Frequency (%) |
| – | 19 |
price
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 9119 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6350.7663 |
| Minimum | 0 |
|---|---|
| Maximum | 1012625.9 |
| Zeros | 2214 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 95 |
| Q1 | 360 |
| median | 899.4 |
| Q3 | 4090 |
| 95-th percentile | 29199 |
| Maximum | 1012625.9 |
| Range | 1012625.9 |
| Interquartile range (IQR) | 3730 |
Descriptive statistics
| Standard deviation | 14951.495 |
|---|---|
| Coefficient of variation (CV) | 2.354282 |
| Kurtosis | 71.228003 |
| Mean | 6350.7663 |
| Median Absolute Deviation (MAD) | 699.4 |
| Skewness | 5.2278765 |
| Sum | 3.7108417 × 109 |
| Variance | 2.235472 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1000 | 11077 | 1.9% |
| 999 | 10119 | 1.7% |
| 500 | 9213 | 1.6% |
| 699 | 8407 | 1.4% |
| 499 | 7693 | 1.3% |
| 399 | 6999 | 1.2% |
| 299 | 6647 | 1.1% |
| 799 | 6024 | 1.0% |
| 599 | 6008 | 1.0% |
| 899 | 4471 | 0.8% |
| Other values (9109) | 507656 |
| Value | Count | Frequency (%) |
| 0 | 2214 | |
| 0.1 | 15 | < 0.1% |
| 0.11 | 8 | < 0.1% |
| 0.15 | 1 | < 0.1% |
| 0.2 | 16 | < 0.1% |
| 0.8 | 9 | < 0.1% |
| 1 | 1237 | |
| 1.3 | 24 | < 0.1% |
| 1.5 | 20 | < 0.1% |
| 1.6 | 34 | < 0.1% |
| Value | Count | Frequency (%) |
| 1012625.9 | 1 | < 0.1% |
| 515975 | 1 | < 0.1% |
| 479000 | 4 | |
| 330499 | 2 | |
| 320000 | 1 | < 0.1% |
| 307970 | 2 | |
| 300000 | 4 | |
| 291667 | 2 | |
| 289999 | 1 | < 0.1% |
| 265499 | 1 | < 0.1% |
qty_ordered
Real number (ℝ)
SKEWED 
| Distinct | 73 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2943075 |
| Minimum | 1 |
|---|---|
| Maximum | 1000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 1000 |
| Range | 999 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.9881503 |
|---|---|
| Coefficient of variation (CV) | 3.0813004 |
| Kurtosis | 42941.241 |
| Mean | 1.2943075 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 185.8821 |
| Sum | 756282 |
| Variance | 15.905343 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 505125 | |
| 2 | 46607 | 8.0% |
| 3 | 15404 | 2.6% |
| 5 | 11202 | 1.9% |
| 4 | 4139 | 0.7% |
| 6 | 588 | 0.1% |
| 10 | 291 | < 0.1% |
| 8 | 153 | < 0.1% |
| 7 | 112 | < 0.1% |
| 12 | 95 | < 0.1% |
| Other values (63) | 598 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 505125 | |
| 2 | 46607 | 8.0% |
| 3 | 15404 | 2.6% |
| 4 | 4139 | 0.7% |
| 5 | 11202 | 1.9% |
| 6 | 588 | 0.1% |
| 7 | 112 | < 0.1% |
| 8 | 153 | < 0.1% |
| 9 | 42 | < 0.1% |
| 10 | 291 | < 0.1% |
| Value | Count | Frequency (%) |
| 1000 | 6 | |
| 502 | 1 | < 0.1% |
| 500 | 4 | |
| 380 | 1 | < 0.1% |
| 304 | 1 | < 0.1% |
| 300 | 2 | < 0.1% |
| 200 | 7 | |
| 187 | 1 | < 0.1% |
| 186 | 1 | < 0.1% |
| 185 | 1 | < 0.1% |
grand_total
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 36828 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8532.8924 |
| Minimum | -1594 |
|---|---|
| Maximum | 17888000 |
| Zeros | 9616 |
| Zeros (%) | 1.6% |
| Negative | 76 |
| Negative (%) | < 0.1% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | -1594 |
|---|---|
| 5-th percentile | 160 |
| Q1 | 945.2 |
| median | 1961 |
| Q3 | 6999 |
| 95-th percentile | 34499 |
| Maximum | 17888000 |
| Range | 17889594 |
| Interquartile range (IQR) | 6053.8 |
Descriptive statistics
| Standard deviation | 61331.682 |
|---|---|
| Coefficient of variation (CV) | 7.1876779 |
| Kurtosis | 74165.691 |
| Mean | 8532.8924 |
| Median Absolute Deviation (MAD) | 1462 |
| Skewness | 254.95417 |
| Sum | 4.9858885 × 109 |
| Variance | 3.7615752 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9616 | 1.6% |
| 1000 | 5145 | 0.9% |
| 2000 | 3780 | 0.6% |
| 2500 | 3235 | 0.6% |
| 5000 | 2912 | 0.5% |
| 1149 | 2524 | 0.4% |
| 12599 | 2520 | 0.4% |
| 399 | 2459 | 0.4% |
| 4000 | 2387 | 0.4% |
| 150 | 2238 | 0.4% |
| Other values (36818) | 547498 |
| Value | Count | Frequency (%) |
| -1594 | 1 | < 0.1% |
| -1311.5 | 7 | |
| -1106.65 | 1 | < 0.1% |
| -873.4 | 1 | < 0.1% |
| -528 | 1 | < 0.1% |
| -511 | 2 | < 0.1% |
| -425.7 | 2 | < 0.1% |
| -384 | 1 | < 0.1% |
| -340.6 | 16 | |
| -249 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 17888000 | 6 | |
| 1315875 | 1 | < 0.1% |
| 1280473 | 2 | < 0.1% |
| 1279980 | 1 | < 0.1% |
| 1155966 | 1 | < 0.1% |
| 1039479 | 1 | < 0.1% |
| 1028751 | 4 | |
| 1012625.9 | 1 | < 0.1% |
| 888065 | 7 | |
| 847024 | 7 |
category_name_1
Categorical
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| Mobiles & Tablets | |
|---|---|
| Men's Fashion | |
| Women's Fashion | |
| Appliances | |
| Superstore | |
| Other values (11) |
Length
| Max length | 18 |
|---|---|
| Median length | 17 |
| Mean length | 12.839496 |
| Min length | 2 |
Characters and Unicode
| Total characters | 7502297 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Women's Fashion |
|---|---|
| 2nd row | Beauty & Grooming |
| 3rd row | Women's Fashion |
| 4th row | Beauty & Grooming |
| 5th row | Soghaat |
Common Values
| Value | Count | Frequency (%) |
| Mobiles & Tablets | 115709 | |
| Men's Fashion | 92218 | |
| Women's Fashion | 59720 | |
| Appliances | 52413 | |
| Superstore | 43611 | 7.5% |
| Beauty & Grooming | 41493 | 7.1% |
| Soghaat | 34011 | 5.8% |
| Others | 29208 | 5.0% |
| Home & Living | 26504 | 4.5% |
| Entertainment | 26322 | 4.5% |
| Other values (6) | 63105 |
Length
| Value | Count | Frequency (%) |
| 221175 | ||
| fashion | 151938 | |
| mobiles | 115709 | |
| tablets | 115709 | |
| men's | 92218 | 7.8% |
| women's | 59720 | 5.1% |
| appliances | 52413 | 4.4% |
| superstore | 43611 | 3.7% |
| beauty | 41493 | 3.5% |
| grooming | 41493 | 3.5% |
| Other values (14) | 243123 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 696387 | 9.3% |
| e | 690342 | 9.2% |
| 594288 | 7.9% | |
| o | 562088 | 7.5% |
| n | 522663 | 7.0% |
| a | 493366 | 6.6% |
| i | 476783 | 6.4% |
| t | 397413 | 5.3% |
| l | 304811 | 4.1% |
| b | 247907 | 3.3% |
| Other values (29) | 2516249 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5569636 | |
| Uppercase Letter | 957427 | 12.8% |
| Space Separator | 594288 | 7.9% |
| Other Punctuation | 380946 | 5.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 696387 | |
| e | 690342 | |
| o | 562088 | |
| n | 522663 | |
| a | 493366 | |
| i | 476783 | |
| t | 397413 | |
| l | 304811 | 5.5% |
| b | 247907 | 4.5% |
| h | 236137 | 4.2% |
| Other values (10) | 941739 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 207927 | |
| F | 151938 | |
| T | 115709 | |
| S | 98602 | |
| B | 59852 | 6.3% |
| W | 59720 | 6.2% |
| A | 52413 | 5.5% |
| H | 44006 | 4.6% |
| G | 41493 | 4.3% |
| E | 29800 | 3.1% |
| Other values (5) | 95967 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 221175 | |
| ' | 151938 | |
| \ | 7833 | 2.1% |
Space Separator
| Value | Count | Frequency (%) |
| 594288 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6527063 | |
| Common | 975234 | 13.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 696387 | 10.7% |
| e | 690342 | 10.6% |
| o | 562088 | 8.6% |
| n | 522663 | 8.0% |
| a | 493366 | 7.6% |
| i | 476783 | 7.3% |
| t | 397413 | 6.1% |
| l | 304811 | 4.7% |
| b | 247907 | 3.8% |
| h | 236137 | 3.6% |
| Other values (25) | 1899166 |
Common
| Value | Count | Frequency (%) |
| 594288 | ||
| & | 221175 | 22.7% |
| ' | 151938 | 15.6% |
| \ | 7833 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7502297 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 696387 | 9.3% |
| e | 690342 | 9.2% |
| 594288 | 7.9% | |
| o | 562088 | 7.5% |
| n | 522663 | 7.0% |
| a | 493366 | 6.6% |
| i | 476783 | 6.4% |
| t | 397413 | 5.3% |
| l | 304811 | 4.1% |
| b | 247907 | 3.3% |
| Other values (29) | 2516249 |
discount_amount
Real number (ℝ)
ZEROS 
| Distinct | 28058 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 499.65533 |
| Minimum | -599.5 |
|---|---|
| Maximum | 90300 |
| Zeros | 376121 |
| Zeros (%) | 64.4% |
| Negative | 3 |
| Negative (%) | < 0.1% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | -599.5 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 160.7344 |
| 95-th percentile | 2930 |
| Maximum | 90300 |
| Range | 90899.5 |
| Interquartile range (IQR) | 160.7344 |
Descriptive statistics
| Standard deviation | 1507.1858 |
|---|---|
| Coefficient of variation (CV) | 3.016451 |
| Kurtosis | 117.52989 |
| Mean | 499.65533 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.8412944 |
| Sum | 2.919556 × 108 |
| Variance | 2271609.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 376121 | |
| 1000 | 5420 | 0.9% |
| 2000 | 4143 | 0.7% |
| 500 | 3648 | 0.6% |
| 200 | 3495 | 0.6% |
| 3000 | 2361 | 0.4% |
| 7000 | 2289 | 0.4% |
| 1500 | 1625 | 0.3% |
| 4000 | 1429 | 0.2% |
| 2200 | 1409 | 0.2% |
| Other values (28048) | 182374 |
| Value | Count | Frequency (%) |
| -599.5 | 1 | < 0.1% |
| -2 | 2 | < 0.1% |
| 0 | 376121 | |
| 0.08 | 1 | < 0.1% |
| 0.1 | 6 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| 0.15 | 36 | < 0.1% |
| 0.16 | 1 | < 0.1% |
| 0.19 | 1 | < 0.1% |
| 0.2 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 90300 | 2 | < 0.1% |
| 50355.25 | 5 | |
| 50127.75 | 5 | |
| 48205 | 1 | < 0.1% |
| 47500 | 4 | |
| 45000 | 1 | < 0.1% |
| 42498.75 | 1 | < 0.1% |
| 41885 | 1 | < 0.1% |
| 38075.07 | 8 | |
| 35609.39 | 1 | < 0.1% |
payment_method
Categorical
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| cod | |
|---|---|
| Payaxis | |
| Easypay | |
| jazzwallet | |
| easypay_voucher | |
| Other values (13) |
Length
| Max length | 17 |
|---|---|
| Median length | 16 |
| Mean length | 6.1909727 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3617472 |
|---|---|
| Distinct characters | 30 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | cod |
|---|---|
| 2nd row | cod |
| 3rd row | cod |
| 4th row | cod |
| 5th row | cod |
Common Values
| Value | Count | Frequency (%) |
| cod | 271770 | |
| Payaxis | 97640 | 16.7% |
| Easypay | 82893 | 14.2% |
| jazzwallet | 35145 | 6.0% |
| easypay_voucher | 31175 | 5.3% |
| bankalfalah | 23057 | 3.9% |
| jazzvoucher | 15633 | 2.7% |
| Easypay_MA | 14026 | 2.4% |
| customercredit | 7554 | 1.3% |
| apg | 1758 | 0.3% |
| Other values (8) | 3663 | 0.6% |
Length
| Value | Count | Frequency (%) |
| cod | 271770 | |
| payaxis | 97640 | 16.7% |
| easypay | 82893 | 14.2% |
| jazzwallet | 35145 | 6.0% |
| easypay_voucher | 31175 | 5.3% |
| bankalfalah | 23057 | 3.9% |
| jazzvoucher | 15633 | 2.7% |
| easypay_ma | 14026 | 2.4% |
| customercredit | 7554 | 1.3% |
| apg | 1758 | 0.3% |
| Other values (8) | 3663 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 635593 | |
| y | 355166 | 9.8% |
| c | 337170 | 9.3% |
| o | 327721 | 9.1% |
| d | 282070 | 7.8% |
| s | 234812 | 6.5% |
| e | 132551 | 3.7% |
| p | 130754 | 3.6% |
| l | 118024 | 3.3% |
| i | 107928 | 3.0% |
| Other values (20) | 955683 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3349660 | |
| Uppercase Letter | 222611 | 6.2% |
| Connector Punctuation | 45201 | 1.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 635593 | |
| y | 355166 | |
| c | 337170 | |
| o | 327721 | |
| d | 282070 | |
| s | 234812 | 7.0% |
| e | 132551 | 4.0% |
| p | 130754 | 3.9% |
| l | 118024 | 3.5% |
| i | 107928 | 3.2% |
| Other values (15) | 687871 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 97640 | |
| E | 96919 | |
| M | 14026 | 6.3% |
| A | 14026 | 6.3% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 45201 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3572271 | |
| Common | 45201 | 1.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 635593 | |
| y | 355166 | 9.9% |
| c | 337170 | 9.4% |
| o | 327721 | 9.2% |
| d | 282070 | 7.9% |
| s | 234812 | 6.6% |
| e | 132551 | 3.7% |
| p | 130754 | 3.7% |
| l | 118024 | 3.3% |
| i | 107928 | 3.0% |
| Other values (19) | 910482 |
Common
| Value | Count | Frequency (%) |
| _ | 45201 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3617472 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 635593 | |
| y | 355166 | 9.8% |
| c | 337170 | 9.3% |
| o | 327721 | 9.1% |
| d | 282070 | 7.8% |
| s | 234812 | 6.5% |
| e | 132551 | 3.7% |
| p | 130754 | 3.6% |
| l | 118024 | 3.3% |
| i | 107928 | 3.0% |
| Other values (20) | 955683 |
BI Status
Categorical
HIGH CORRELATION 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| Net | |
|---|---|
| Gross | |
| Valid | |
| #REF! | 1 |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.1984549 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2453216 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | #REF! |
|---|---|
| 2nd row | Gross |
| 3rd row | Gross |
| 4th row | Net |
| 5th row | Valid |
Common Values
| Value | Count | Frequency (%) |
| Net | 234177 | |
| Gross | 201317 | |
| Valid | 148819 | |
| #REF! | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| net | 234177 | |
| gross | 201317 | |
| valid | 148819 | |
| ref | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 402634 | |
| N | 234177 | |
| t | 234177 | |
| e | 234177 | |
| G | 201317 | |
| r | 201317 | |
| o | 201317 | |
| i | 148819 | 6.1% |
| d | 148819 | 6.1% |
| a | 148819 | 6.1% |
| Other values (7) | 297643 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1868898 | |
| Uppercase Letter | 584316 | 23.8% |
| Other Punctuation | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 402634 | |
| t | 234177 | |
| e | 234177 | |
| r | 201317 | |
| o | 201317 | |
| i | 148819 | 8.0% |
| d | 148819 | 8.0% |
| a | 148819 | 8.0% |
| l | 148819 | 8.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 234177 | |
| G | 201317 | |
| V | 148819 | |
| R | 1 | < 0.1% |
| E | 1 | < 0.1% |
| F | 1 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| # | 1 | |
| ! | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2453214 | |
| Common | 2 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 402634 | |
| N | 234177 | |
| t | 234177 | |
| e | 234177 | |
| G | 201317 | |
| r | 201317 | |
| o | 201317 | |
| i | 148819 | 6.1% |
| d | 148819 | 6.1% |
| a | 148819 | 6.1% |
| Other values (5) | 297641 |
Common
| Value | Count | Frequency (%) |
| # | 1 | |
| ! | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2453216 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 402634 | |
| N | 234177 | |
| t | 234177 | |
| e | 234177 | |
| G | 201317 | |
| r | 201317 | |
| o | 201317 | |
| i | 148819 | 6.1% |
| d | 148819 | 6.1% |
| a | 148819 | 6.1% |
| Other values (7) | 297643 |
MV
Text
| Distinct | 9720 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 4.144573 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2421732 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2234 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 1,950 |
|---|---|
| 2nd row | 240 |
| 3rd row | 2,450 |
| 4th row | 360 |
| 5th row | 1,110 |
| Value | Count | Frequency (%) |
| 999 | 9515 | 1.6% |
| 699 | 7801 | 1.3% |
| 499 | 7157 | 1.2% |
| 1,000 | 6894 | 1.2% |
| 399 | 6506 | 1.1% |
| 299 | 5997 | 1.0% |
| 599 | 5721 | 1.0% |
| 799 | 5715 | 1.0% |
| 2,000 | 4498 | 0.8% |
| 899 | 4353 | 0.7% |
| Other values (9710) | 520157 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 414270 | |
| 9 | 399021 | |
| , | 289292 | |
| 1 | 247183 | |
| 5 | 220100 | |
| 2 | 188201 | |
| 4 | 151871 | 6.3% |
| 3 | 146602 | 6.1% |
| 8 | 128584 | 5.3% |
| 6 | 117159 | 4.8% |
| Other values (3) | 119449 | 4.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2121370 | |
| Other Punctuation | 289292 | 11.9% |
| Space Separator | 8856 | 0.4% |
| Dash Punctuation | 2214 | 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 414270 | |
| 9 | 399021 | |
| 1 | 247183 | |
| 5 | 220100 | |
| 2 | 188201 | |
| 4 | 151871 | 7.2% |
| 3 | 146602 | 6.9% |
| 8 | 128584 | 6.1% |
| 6 | 117159 | 5.5% |
| 7 | 108379 | 5.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 289292 |
Space Separator
| Value | Count | Frequency (%) |
| 8856 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2214 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2421732 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 414270 | |
| 9 | 399021 | |
| , | 289292 | |
| 1 | 247183 | |
| 5 | 220100 | |
| 2 | 188201 | |
| 4 | 151871 | 6.3% |
| 3 | 146602 | 6.1% |
| 8 | 128584 | 5.3% |
| 6 | 117159 | 4.8% |
| Other values (3) | 119449 | 4.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2421732 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 414270 | |
| 9 | 399021 | |
| , | 289292 | |
| 1 | 247183 | |
| 5 | 220100 | |
| 2 | 188201 | |
| 4 | 151871 | 6.3% |
| 3 | 146602 | 6.1% |
| 8 | 128584 | 5.3% |
| 6 | 117159 | 4.8% |
| Other values (3) | 119449 | 4.9% |
Customer Since
Date
| Distinct | 26 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| Minimum | 2016-07-01 00:00:00 |
|---|---|
| Maximum | 2018-08-01 00:00:00 |
Customer ID
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 115304 |
|---|---|
| Distinct (%) | 19.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45779.112 |
| Minimum | 1 |
|---|---|
| Maximum | 115326 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 546 |
| Q1 | 13511 |
| median | 42850 |
| Q3 | 73513.75 |
| 95-th percentile | 107029 |
| Maximum | 115326 |
| Range | 115325 |
| Interquartile range (IQR) | 60002.75 |
Descriptive statistics
| Standard deviation | 34411.486 |
|---|---|
| Coefficient of variation (CV) | 0.75168531 |
| Kurtosis | -1.125135 |
| Mean | 45779.112 |
| Median Absolute Deviation (MAD) | 29886 |
| Skewness | 0.32681856 |
| Sum | 2.6749376 × 1010 |
| Variance | 1.1841504 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 85775 | 2524 | 0.4% |
| 163 | 2349 | 0.4% |
| 35 | 1877 | 0.3% |
| 33 | 1397 | 0.2% |
| 31025 | 1369 | 0.2% |
| 806 | 1310 | 0.2% |
| 1404 | 1269 | 0.2% |
| 767 | 1234 | 0.2% |
| 820 | 1190 | 0.2% |
| 58 | 1182 | 0.2% |
| Other values (115294) | 568613 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 2 | 2 | < 0.1% |
| 3 | 5 | < 0.1% |
| 4 | 428 | |
| 5 | 1 | < 0.1% |
| 6 | 2 | < 0.1% |
| 7 | 4 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 115326 | 1 | < 0.1% |
| 115325 | 2 | |
| 115324 | 1 | < 0.1% |
| 115323 | 1 | < 0.1% |
| 115322 | 2 | |
| 115321 | 1 | < 0.1% |
| 115320 | 3 | |
| 115319 | 3 | |
| 115318 | 1 | < 0.1% |
| 115317 | 1 | < 0.1% |
Year
Categorical
HIGH CORRELATION 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| 2017 | |
|---|---|
| 2018 | |
| 2016 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2337256 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2016 |
|---|---|
| 2nd row | 2016 |
| 3rd row | 2016 |
| 4th row | 2016 |
| 5th row | 2016 |
Common Values
| Value | Count | Frequency (%) |
| 2017 | 290908 | |
| 2018 | 159505 | |
| 2016 | 133901 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2017 | 290908 | |
| 2018 | 159505 | |
| 2016 | 133901 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 584314 | |
| 0 | 584314 | |
| 1 | 584314 | |
| 7 | 290908 | |
| 8 | 159505 | 6.8% |
| 6 | 133901 | 5.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2337256 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 584314 | |
| 0 | 584314 | |
| 1 | 584314 | |
| 7 | 290908 | |
| 8 | 159505 | 6.8% |
| 6 | 133901 | 5.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2337256 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 584314 | |
| 0 | 584314 | |
| 1 | 584314 | |
| 7 | 290908 | |
| 8 | 159505 | 6.8% |
| 6 | 133901 | 5.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2337256 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 584314 | |
| 0 | 584314 | |
| 1 | 584314 | |
| 7 | 290908 | |
| 8 | 159505 | 6.8% |
| 6 | 133901 | 5.7% |
Month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.1687261 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 4 |
| median | 7 |
| Q3 | 11 |
| 95-th percentile | 11 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 3.4862632 |
|---|---|
| Coefficient of variation (CV) | 0.48631559 |
| Kurtosis | -1.3723719 |
| Mean | 7.1687261 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.19349323 |
| Sum | 4188787 |
| Variance | 12.154031 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11 | 155453 | |
| 5 | 62571 | |
| 3 | 61470 | 10.5% |
| 8 | 48512 | 8.3% |
| 7 | 39146 | 6.7% |
| 2 | 38763 | 6.6% |
| 6 | 34526 | 5.9% |
| 4 | 33985 | 5.8% |
| 10 | 30619 | 5.2% |
| 12 | 29196 | 5.0% |
| Other values (2) | 50073 | 8.6% |
| Value | Count | Frequency (%) |
| 1 | 26050 | |
| 2 | 38763 | |
| 3 | 61470 | |
| 4 | 33985 | |
| 5 | 62571 | |
| 6 | 34526 | |
| 7 | 39146 | |
| 8 | 48512 | |
| 9 | 24023 | 4.1% |
| 10 | 30619 |
| Value | Count | Frequency (%) |
| 12 | 29196 | 5.0% |
| 11 | 155453 | |
| 10 | 30619 | 5.2% |
| 9 | 24023 | 4.1% |
| 8 | 48512 | 8.3% |
| 7 | 39146 | 6.7% |
| 6 | 34526 | 5.9% |
| 5 | 62571 | |
| 4 | 33985 | 5.8% |
| 3 | 61470 | 10.5% |
M-Y
Date
| Distinct | 26 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| Minimum | 2016-07-01 00:00:00 |
|---|---|
| Maximum | 2018-08-01 00:00:00 |
| item_id | price | qty_ordered | grand_total | discount_amount | Customer ID | Month | status | category_name_1 | payment_method | BI Status | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| item_id | 1.000 | 0.179 | 0.168 | 0.294 | 0.144 | 0.767 | -0.275 | 0.153 | 0.194 | 0.289 | 0.213 | 0.927 |
| price | 0.179 | 1.000 | -0.162 | 0.730 | 0.282 | 0.221 | -0.057 | 0.028 | 0.045 | 0.070 | 0.039 | 0.052 |
| qty_ordered | 0.168 | -0.162 | 1.000 | 0.058 | -0.049 | 0.126 | -0.158 | 0.001 | 0.005 | 0.007 | 0.002 | 0.004 |
| grand_total | 0.294 | 0.730 | 0.058 | 1.000 | 0.247 | 0.277 | -0.113 | 0.000 | 0.004 | 0.012 | 0.001 | 0.003 |
| discount_amount | 0.144 | 0.282 | -0.049 | 0.247 | 1.000 | 0.099 | 0.057 | 0.016 | 0.047 | 0.066 | 0.020 | 0.009 |
| Customer ID | 0.767 | 0.221 | 0.126 | 0.277 | 0.099 | 1.000 | -0.206 | 0.105 | 0.209 | 0.222 | 0.154 | 0.673 |
| Month | -0.275 | -0.057 | -0.158 | -0.113 | 0.057 | -0.206 | 1.000 | 0.111 | 0.168 | 0.176 | 0.155 | 0.486 |
| status | 0.153 | 0.028 | 0.001 | 0.000 | 0.016 | 0.105 | 0.111 | 1.000 | 0.083 | 0.154 | 0.816 | 0.225 |
| category_name_1 | 0.194 | 0.045 | 0.005 | 0.004 | 0.047 | 0.209 | 0.168 | 0.083 | 1.000 | 0.135 | 0.160 | 0.271 |
| payment_method | 0.289 | 0.070 | 0.007 | 0.012 | 0.066 | 0.222 | 0.176 | 0.154 | 0.135 | 1.000 | 0.331 | 0.359 |
| BI Status | 0.213 | 0.039 | 0.002 | 0.001 | 0.020 | 0.154 | 0.155 | 0.816 | 0.160 | 0.331 | 1.000 | 0.180 |
| Year | 0.927 | 0.052 | 0.004 | 0.003 | 0.009 | 0.673 | 0.486 | 0.225 | 0.271 | 0.359 | 0.180 | 1.000 |
| item_id | status | created_at | sku | price | qty_ordered | grand_total | category_name_1 | discount_amount | payment_method | BI Status | MV | Customer Since | Customer ID | Year | Month | M-Y | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 211131 | complete | 2016-07-01 | kreations_YI 06-L | 1950.0 | 1 | 1950.0 | Women's Fashion | 0.0 | cod | #REF! | 1,950 | 2016-07-01 | 1.0 | 2016 | 7 | 2016-07-01 |
| 1 | 211133 | canceled | 2016-07-01 | kcc_Buy 2 Frey Air Freshener & Get 1 Kasual Body Spray Free | 240.0 | 1 | 240.0 | Beauty & Grooming | 0.0 | cod | Gross | 240 | 2016-07-01 | 2.0 | 2016 | 7 | 2016-07-01 |
| 2 | 211134 | canceled | 2016-07-01 | Ego_UP0017-999-MR0 | 2450.0 | 1 | 2450.0 | Women's Fashion | 0.0 | cod | Gross | 2,450 | 2016-07-01 | 3.0 | 2016 | 7 | 2016-07-01 |
| 3 | 211135 | complete | 2016-07-01 | kcc_krone deal | 360.0 | 1 | 60.0 | Beauty & Grooming | 300.0 | cod | Net | 360 | 2016-07-01 | 4.0 | 2016 | 7 | 2016-07-01 |
| 4 | 211136 | order_refunded | 2016-07-01 | BK7010400AG | 555.0 | 2 | 1110.0 | Soghaat | 0.0 | cod | Valid | 1,110 | 2016-07-01 | 5.0 | 2016 | 7 | 2016-07-01 |
| 5 | 211137 | canceled | 2016-07-01 | UK_Namkino All In One 200 Gms | 80.0 | 1 | 80.0 | Soghaat | 0.0 | cod | Gross | 80 | 2016-07-01 | 6.0 | 2016 | 7 | 2016-07-01 |
| 6 | 211138 | complete | 2016-07-01 | kcc_krone deal | 360.0 | 1 | 60.0 | Beauty & Grooming | 300.0 | cod | Net | 360 | 2016-07-01 | 7.0 | 2016 | 7 | 2016-07-01 |
| 7 | 211139 | complete | 2016-07-01 | UK_Namkino Mix Nimco 400 Gms | 170.0 | 1 | 170.0 | Soghaat | 0.0 | cod | Net | 170 | 2016-07-01 | 6.0 | 2016 | 7 | 2016-07-01 |
| 8 | 211140 | canceled | 2016-07-01 | Apple iPhone 6S 64GB | 96499.0 | 1 | 96499.0 | Mobiles & Tablets | 0.0 | ublcreditcard | Gross | 96,499 | 2016-07-01 | 8.0 | 2016 | 7 | 2016-07-01 |
| 9 | 211141 | canceled | 2016-07-01 | Apple iPhone 6S 64GB | 96499.0 | 1 | 96499.0 | Mobiles & Tablets | 0.0 | mygateway | Gross | 96,499 | 2016-07-01 | 8.0 | 2016 | 7 | 2016-07-01 |
| item_id | status | created_at | sku | price | qty_ordered | grand_total | category_name_1 | discount_amount | payment_method | BI Status | MV | Customer Since | Customer ID | Year | Month | M-Y | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 584514 | 905196 | paid | 2018-08-28 | MEFGUL5A9F882AA5B99-36 | 1299.0 | 1 | 0.0 | Men's Fashion | 0.0 | customercredit | Valid | 1,299 | 2018-06-01 | 111132.0 | 2018 | 8 | 2018-08-01 |
| 584515 | 905198 | paid | 2018-08-28 | MEFPAK5B360B03C6B72 | 999.0 | 1 | 0.0 | Men's Fashion | 0.0 | customercredit | Valid | 999 | 2018-06-01 | 111132.0 | 2018 | 8 | 2018-08-01 |
| 584516 | 905199 | pending | 2018-08-28 | MATINF59BAB39FDBEF1 | 6760.0 | 2 | 13770.0 | Mobiles & Tablets | 0.0 | jazzvoucher | Gross | 13,520 | 2016-09-01 | 8123.0 | 2018 | 8 | 2018-08-01 |
| 584517 | 905200 | cod | 2018-08-28 | WOFVAL59D5EA84167F9-M | 400.0 | 1 | 550.0 | Women's Fashion | 0.0 | cod | Valid | 400 | 2018-08-01 | 115325.0 | 2018 | 8 | 2018-08-01 |
| 584518 | 905202 | cod | 2018-08-28 | WOFNIG5B4D7EB0E9FDD-L | 499.0 | 1 | 649.0 | Women's Fashion | 0.0 | cod | Valid | 499 | 2018-08-01 | 115325.0 | 2018 | 8 | 2018-08-01 |
| 584519 | 905204 | cod | 2018-08-28 | WOFSCE5AE00357AECDE | 699.0 | 1 | 849.0 | Women's Fashion | 0.0 | cod | Valid | 699 | 2018-08-01 | 115320.0 | 2018 | 8 | 2018-08-01 |
| 584520 | 905205 | processing | 2018-08-28 | MATHUA5AF70A7D1E50A | 35599.0 | 1 | 35899.0 | Mobiles & Tablets | 0.0 | bankalfalah | Gross | 35,599 | 2018-08-01 | 115326.0 | 2018 | 8 | 2018-08-01 |
| 584521 | 905206 | processing | 2018-08-28 | MATSAM5B6D7208C6D30 | 129999.0 | 2 | 652178.0 | Mobiles & Tablets | 0.0 | bankalfalah | Gross | 259,998 | 2018-07-01 | 113474.0 | 2018 | 8 | 2018-08-01 |
| 584522 | 905207 | processing | 2018-08-28 | MATSAM5B1509B4696EA | 87300.0 | 2 | 652178.0 | Mobiles & Tablets | 0.0 | bankalfalah | Gross | 174,600 | 2018-07-01 | 113474.0 | 2018 | 8 | 2018-08-01 |
| 584523 | 905208 | processing | 2018-08-28 | MATSAM5B10F91A9B6AB | 108640.0 | 2 | 652178.0 | Mobiles & Tablets | 0.0 | bankalfalah | Gross | 217,280 | 2018-07-01 | 113474.0 | 2018 | 8 | 2018-08-01 |